﻿<!DOCTYPE html>
<html>
<head>
    <title>Goal Seek</title>
    <meta charset="utf-8" />
    <meta name="description" content="Set data validation parameters to control further spreadsheet editing" />
    <link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
    <link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
    <script type="text/javascript" src="../callback.js"></script>
    <script type="text/javascript" src="../search/js/page-search.js"></script>
</head>
<body>
    <div class="mainpart">
        <div class="search-field">
            <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
        </div>
        <h1>Goal Seek</h1>
        <p>ONLYOFFICE <a href="https://www.onlyoffice.com/spreadsheet-editor.aspx" target="_blank" onclick="onhyperlinkclick(this)"><b>Spreadsheet Editor</b></a> offers a <b>Goal Seek</b> feature that allows you to determine which numbers should be substituted into the formula to obtain the desired and previously known result.</p>
        <ol>
            <li>Open the <b>Data</b> tab and click the <b>Goal Seek</b> icon on the top toolbar.</li>
            <li>In the opened <b>Goal Seek</b> window, select the necessary options:
                <p><img alt="Goal Seek" src="../images/goal_seek.png" /></p>
            <ul>
                <li><b>Set cell</b> - enter the reference to the cell that contains a formula. You can use the <div class="icon icon-changerange"></div> icon to select the cell.</li>
                <li><b>To value</b> - enter the result you want to get in the cell containing the formula.</li>
                <li><b>By changing cell</b> - enter the reference to the cell that that contains the value you want to change. You can use the <div class="icon icon-changerange"></div> icon to select the cell. This cell must be referenced by the formula located in the cell which you specified in the <b>Set cell</b> field.</li>
            </ul>
            </li>
            <li>Click <b>OK</b>.</li>
            <li>The  <b>Goal Seek Status</b> window will display the result.
                <p><img alt="Goal Seek status" src="../images/goal_seek_status.png" /></p>
            </li>
            <li>Click <b>OK</b> to replace the values in the the cells specified in the <b>Set cell</b> and <b>By changing cell</b> fields.</li>
        </ol>
        
    </div>
</body>
</html>